Automations

Database Commands

  • Version: 1.4.0
  • Official Verified

OpenBots command for connecting to and executing queries against a database. Supports OLE DB.

OpenBots.Commands.Database \ Execute Database Query Command

Command: Execute Database Query Command

This command performs a OleDb database query.

Parameters

Database Instance Name

Enter the unique instance that was specified in the **Define Database Connection** command.

Required

Define Query Execution Type

Select the appropriate query execution type.

Required

Query

Define the OleDb query to execute.

Required

Query Parameters

Define the query parameters.

Required

Query Timeout (seconds)

Enter the wait time before terminating an attempt to execute a query and generate an error.

Required

Output Dataset Variable

Create a new variable or select a variable from the list.

Required

Private (Optional)

Optional field to mark the command as private (data sensitive) in order to avoid its logging.

Comment Field (Optional)

Optional field to enter a custom comment which could potentially describe this command or the need for this command, if required.

Logo